Clicking the link ([url]http://strengthscene.com/index.php?p=u/smash)to[/url] view any profile results produces:

[quote]SQL query error!
Error infomation:[SQL]
select * from jcow_disliked where stream_id='265' and uid='1' limit 1

[Error]
Table 'bmfiron1_jcow1.jcow_disliked' doesn't exist

You can get help by sending this infomation to us: [url]http://jcow.net[/quote][/url]

Please advise.

Step.1
Excute the following SQL queries:
ALTER TABLE jcow_streams ADD dislikes INT NOT NULL ;
CREATE TABLE IF NOT EXISTS jcow_disliked (
id int(11) NOT NULL auto_increment,
uid int(11) NOT NULL,
stream_id int(11) NOT NULL,
PRIMARY KEY (id),
KEY uid (uid,stream_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS jcow_disliked (
id int(11) NOT NULL auto_increment,
uid int(11) NOT NULL,
stream_id int(11) NOT NULL,
PRIMARY KEY (id),
KEY uid (uid,stream_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

Step.2
Replace following files:
files/icons/thumbs_up.png
files/icons/thumbs_down.png
files/common_css/style.css
files/common_css/sharebox_arrow_bg.gif
files/common_css/sharebox_arrow.png
js/facebox

I have no idea how to do step 1, so I'll have to find someone who can. Thanks for posting this because I can show it to them to help

I installed but I got this error

The requested URL /www.....com/index.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Log into your server and goto PhpMyAdmin. Then open your jcow database and select on query, then cut and past the code, and click on GO..

I tried that and got:

[quote]Error

SQL query: Documentation

SELECT *
FROM jcow_profiles
WHERE 1
ALTER TABLE jcow_streams ADD dislikes INT NOT NULL ;

MySQL said: Documentation

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE jcow_streams ADD dislikes INT NOT NULL' at line 3 [/quote]

What did I do wrong?

OMFG! I am such a major dork and, conversely, you freaking ROCK!

I had left [b]SELECT * FROM jcow_profiles WHERE 1[/b] in the query box at first because I didn't know if I should remove it. Result = error.

I pulled it out and pasted it in Notepad in case I needed it again. Then I copied and pasted the code like you said and IT WORKED! THANK YOU!

I'm a marketer, not a developer, so I get lost easily. Thanks for making this work. YOU ROCK!

I got too excited too soon. After refreshing a couple of times, the site won't connect at all.

I copied and pasted the quoted content into localhost >> bmfiron1_jcow1 >> jcow_profiles

[quote]ALTER TABLE jcow_streams ADD dislikes INT NOT NULL ;
CREATE TABLE IF NOT EXISTS jcow_disliked (
id int(11) NOT NULL auto_increment,
uid int(11) NOT NULL,
stream_id int(11) NOT NULL,
PRIMARY KEY (id),
KEY uid (uid,stream_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS jcow_disliked (
id int(11) NOT NULL auto_increment,
uid int(11) NOT NULL,
stream_id int(11) NOT NULL,
PRIMARY KEY (id),
KEY uid (uid,stream_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;[/quote]

What did I do wrong?

1

bmfiron1_jcow1 ONLY Not in anyother

I hope your made a copy of your database.

1

I panicked too soon (again). It was a temporary server issue at the host.

Interesting to note:
When I first made the mod and refreshed, the action indicated Submitting, and wouldn't go away no matter what.

Then, after the site went down and came back, it worked flawlessly.

Thanks again!

Dude, how the heck did putting that code in ONE time in ONE area fix the query errors for other sections?

Well, however it works, thank you again for showing me how to do it. You make it seem so simple! LOL

1